LogDoor User's Guide

Appendix 2 - File Formats

This appendix describes the formats of LogDoor's input and output files.

Input log file: The input log file to LogDoor 1.0 must be a TEXT file in standard MacHTTP or WebSTAR log format. Both of these formats consist of a series of entries, with each entry terminated by a single return character (ASCII $0D). Fields within an entry are terminated by a single tab character (ASCII $09). MacHTTP log format consists of precisely the following fields in the following order:

Date - the date is always in mm/dd/yy format, with two digits each for the month, day and year.

Time - the time is always in 24 hour format hh:mm:ss, with two digits each for the hour, minute and second.

Status - either "OK" indicating a successful access, "ERR!" indicating an error on access (usually an invalid URL), or "PRIV" indicating access to a password-protected URL. Note that traditionally the "OK" status code is followed by two space characters: "OK ".

IP address - the IP address (or domain name, if the server is using DNS lookups to replace IP addresses with domain names) of the requesting machine.

URL - the URL which was accessed. This field always begins with a colon, and uses colons to delimit directory names.

Number of bytes transfered.

The WebSTAR log format is more complex. A WebSTAR log can consist of any of a number of fields in any order desired by the WebSTAR administrator. A WebSTAR log begins with a log format line which indicates the precise fields in any entries which follow that line. Subsequent formatting lines can appear anywhere within the file. A format line always begins with two exclamation point characters (!!). Details of the WebSTAR log format are described in the WebSTAR Users' Guide.

NOTE: A bug in WebSTAR versions prior to 1.3 could result in logs being written which do not begin with a log format line. LogDoor will usually be able to interpret such log files correctly anyway. Under some rare conditions, if you use an unusual log file format and encounter this bug, you may manually need to add a log format line to the log, using a text editor.

Output log files: LogDoor can produce one output log file for each site encountered in the input log file. Such output log files will always be formatted like the input log file. Specifically, if the input log file is in MacHTTP format, the output log files will also be in that format. If the input log file is in WebSTAR format, the output files will also be in that format, with log format lines echoed to all output log files as appropriate.

Output HTML-formatted summary reports: LogDoor's HTML-formatted reports consist of a header and a day-by-day access table. Detailed information for the last 90 days is included, plus a summary of all information before that period. The overall report also includes a site-by-site access table, with each site name acting as a link to the individual report for that site. The general format of the site-specific reports is as follows:

<HTML><HEAD><TITLE>site1 Summary</TITLE></HEAD><BODY><CENTER><B>LogDoor Statistics Summary</B></CENTER> ***This line is replaced with Heading.html *** 
<CENTER><B>Summary Prepared: 06/20/96 06:54<BR>Site: site1<BR></B><P><B>Daily Totals</B><P><TABLE BORDER CELLSPACING=2><TR ALIGN=CENTER><TD WIDTH=50><B>Date</B></TD><TD WIDTH=50><B>Hits</B></TD><TD WIDTH=50><B>Bytes</B></TD><TD WIDTH=50><B>Errors</B></TD></TR><P><TR ALIGN=RIGHT><TD ALIGN=LEFT>06/01/96</TD><TD>5</TD><TD>25K</TD><TD>0</TD></TR><P>
etc.

<TR ALIGN=RIGHT><TD ALIGN=LEFT>Totals</TD><TD>5</TD><TD>25K</TD><TD>0</TD></TR><P></TABLE><P></CENTER></BODY></HTML>

Sample reports are available on the LogDoor Web pages.

Output text-formatted summary reports: LogDoor's text-formatted reports contain equivalent information to that in the HTML-formatted reports, however fields are tab-delimited rather than being included in a table. Such reports should be directly importable into any spreadsheet application. The general format of these reports is as follows:

LogDoor Statistics: Summary ***This line is replaced with Heading.txt *** 
Summary Prepared:       06/20/96 06:54
Site:   site1

Daily Totals

Date    Hits    Bytes   Errors

06/01/96        5       26123     0
etc.

Totals  5       26123    0

Sample reports are available on the LogDoor Web pages.

Heading files: LogDoor's summary reports will include text in files named Heading.html and Heading.txt if such files are found in the same folder as the task file when the reports are written. The text in files Heading.html and Heading.txt will replace the line indicated above in the HTML- and text-formatted reports respectively. Sample Heading.html and Heading.txt files are included with LogDoor.

Back to Table of Contents
Back to Appendix 1